If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

If you want to use a code to find a description of something, a table and a lookup function can be used. You would search a column for a code and when it is found you would look at the column that has the description, to the cell on the same row. Lookup functions can also be used where you might use an IF function, when there are ranges of values involved. Grading for exam results would be an example. So if you had gradings like A, B, C, D etc. for different ranges of marks, you could use a lookup table to find where the marks fit and give the appropriate grade. This can be simpler than a corresponding IF, which could be quite long.

Resources

Top Categories

Product

Company